Creating an environment for linking knowledge-based systems to a clinical database: a suite of tools

A difficulty in using knowledge-based systems has been linking them to clinical databases. The challenge is in making a correct mapping from the data in the knowledge base to the data in the database. At Columbia-Presbyterian Medical Center, we have built a suite of tools developed to create queries that address this challenge. The tools were designed to allow users to easily retrieve data from the database without requiring the users have extensive database and vocabulary knowledge. The tools help users write correct queries (Query Builder), find correct terms in the clinical database (MED Browser), aggregate the resulting data into a useful form (Clinical Database Browser), and allow the user to test the query within the environment of the knowledge-based system (Event Playback). The tools have been in use for one year.